export const DepartmentQueries = {
    GetDepartments: `
    SELECT
      id,
      departmentName,
      departmentDescription,
      departmentPhoneNumber
    FROM my_schema.department
    `,
  
    GetDepartmentById: `
    SELECT
      id,
      departmentName,
      departmentDescription,
      departmentPhoneNumber
    FROM my_schema.department
    WHERE
      id = ?
    `,
  
    AddDepartment: `
    INSERT INTO my_schema.department (departmentName, departmentDescription, departmentPhoneNumber)
      VALUES ?
    `,

    UpdateDepartmentById: `
    UPDATE my_schema.department
    SET ?
    WHERE
      id = ?
    `,
  
    DeleteDepartmentById: `
    DELETE FROM my_schema.department
    WHERE
      id = ?
    `
  };